﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Dados_alunos.aspx.cs" Inherits="Qvaliz.CAD.Relatorios.Dados_alunos" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<%@ Register src="../Usercontrol/wuscSeguranca.ascx" tagname="wuscSeguranca" tagprefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"> 
<head id="Head1" runat="server"> 
    <title></title> 
    <script type="text/javascript">
        function RowDblClick(sender, eventArgs) {
            sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());

        } 
    </script> 
</head> 
<body> 
    <form id="form1" runat="server"> 
    <asp:ObjectDataSource ID="ods_DadosAlunos" runat="server"  
        SelectMethod="_obter_Dados_Aluno" TypeName="Banco.BD_Aluno" 
        onselecting="ods_DadosAlunos_Selecting"> 
        <SelectParameters> 
            <asp:Parameter Name="ALUNO_ID" Type="String" /> 
            <asp:Parameter Name="NOME_ALUNO" Type="String" /> 
            <asp:Parameter Name="END_LOGRADOURO" Type="String" />
            <asp:Parameter Name="END_NUMERO" Type="String" />
            <asp:Parameter Name="END_COMPLEMENTO" Type="String" />
            <asp:Parameter Name="END_BAIRRO" Type="String" />
            <asp:Parameter Name="END_CIDADE" Type="String" />
            <asp:Parameter Name="END_UF" Type="String" />
            <asp:Parameter Name="END_CEP" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_RESALUNO" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_COMALUNO" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_CELALUNO" Type="String" />
            <asp:Parameter Name="PES_EMAIL" Type="String" />
            <asp:Parameter Name="PES_DTNASCIMENTO" Type="String" />
            <asp:Parameter Name="NOME_PAI" Type="String" />
            <asp:Parameter Name="CPF_PAI" Type="String" />
            <asp:Parameter Name="NOME_MAE" Type="String" />
            <asp:Parameter Name="CPF_MAE" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_RESPAI" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_CELPAI" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_RESMAE" Type="String" />
            <asp:Parameter Name="PSC_TELEFONE_CELMAE" Type="String" />
            <asp:Parameter Name="PRF_DESCRICAO_PAI" Type="String" />
            <asp:Parameter Name="PRF_DESCRICAO_MAE" Type="String" />
            <asp:Parameter Name="MAT_DTINCLUSAO" Type="String" />
            <asp:Parameter Name="MAT_DATACOBRANCA" Type="String" />
            <asp:Parameter Name="TURMA_ID" Type="String" />
            <asp:Parameter Name="MOD_DESCRICAO" Type="String" />
            <asp:Parameter Name="NIV_DESCRICAO" Type="String" />
            <asp:Parameter Name="TUR_DESCRICAO" Type="String" />
            <asp:Parameter Name="ALU_BOLSISTA" Type="String" />
            <asp:Parameter Name="MAT_VRMENSALIDADE" Type="String" />
            <asp:Parameter Name="MAT_ISENTOTXPARTICIPACAO" Type="String" />
            <asp:Parameter Name="MAT_TXPARTICIPACAO" Type="String" />
            <asp:Parameter Name="ALU_MEDICAMENTO" Type="String" />
            <asp:Parameter Name="CNV_DESCRICAO" Type="String" />
            <asp:Parameter Name="ALU_OBSERVACAO" Type="String" />
            <asp:Parameter Name="ALU_STEXCLUIDO" Type="String" />
            <asp:Parameter Name="ORDER_BY_CLAUSE" Type="String" />
        </SelectParameters> 
    </asp:ObjectDataSource> 
     
    <uc1:wuscSeguranca ID="wuscSeguranca1" runat="server" />
    
    
    <div> 
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> 
        </telerik:RadScriptManager> 
 
        <telerik:RadAjaxLoadingPanel ID="ralpGrid" runat="server" Skin="Default"> 
          </telerik:RadAjaxLoadingPanel> 
 
                 <telerik:RadAjaxPanel ID="rapGrid" runat="server" Height="350px" 
                    Width="100%" HorizontalAlign="NotSet" LoadingPanelID="ralpGrid" 
                    onajaxrequest="rapGrid_AjaxRequest"> 
 
        <telerik:RadGrid ID="rdg_DadosAlunos" runat="server" AutoGenerateColumns="False"  
                GridLines="None" Skin="Sunset" AllowSorting="True"  
                DataSourceID="ods_DadosAlunos" AllowAutomaticDeletes="True"  
                AllowAutomaticInserts="True" AllowAutomaticUpdates="True"  
                AllowFilteringByColumn="True" AllowPaging="True" >  
                <ClientSettings> 
                    <Selecting AllowRowSelect="True" /> 
                    <ClientEvents OnRowDblClick="RowDblClick" /> 
                    <Scrolling AllowScroll="True" UseStaticHeaders="True" /> 
                </ClientSettings> 
    <MasterTableView datasourceid="ods_DadosAlunos" commanditemdisplay="Top" EditMode="PopUp" 
                    ClientDataKeyNames="ALUNO_ID" DataKeyNames="ALUNO_ID" PageSize="50" > 
        <CommandItemSettings AddNewRecordText="Adicionar Novo registro"  
            ExportToCsvText="Exportar para CSV" ExportToExcelText="Exportar para Excel"  
            ExportToPdfText="Exportar para PDF" ShowExportToExcelButton="True"  
            ShowExportToPdfButton="True" RefreshText="Atualizar" 
            ShowAddNewRecordButton="False" /> 
        <Columns> 
            <telerik:GridBoundColumn DataField="ALUNO_ID" HeaderText="Código"  ReadOnly="true" Visible="false" FilterControlWidth="35px"
                UniqueName="ALUNO_ID"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="NOME_ALUNO" HeaderText="Aluno"   Visible="false" FilterControlWidth="35px"
                UniqueName="NOME_ALUNO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="END_LOGRADOURO" HeaderText="Endereço"   Visible="false" FilterControlWidth="35px"
                UniqueName="END_LOGRADOURO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_RESALUNO" HeaderText="Tel Aluno"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_RESALUNO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_CELALUNO" HeaderText="Cel Aluno"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_CELALUNO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_COMALUNO" HeaderText="Tel Comercial"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_COMALUNO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PES_EMAIL" HeaderText="E-mail"   Visible="false" FilterControlWidth="35px"
                UniqueName="PES_EMAIL"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PES_DTNASCIMENTO" HeaderText="Nascimento"   Visible="false" FilterControlWidth="35px"
                UniqueName="PES_DTNASCIMENTO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="NOME_PAI" HeaderText="Nome Pai"  ReadOnly="true" Visible="false" FilterControlWidth="35px"
                UniqueName="NOME_PAI"> 
                <HeaderStyle Width="120px" /> 
                <ItemStyle Font-Size="X-Small" Width="120px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="CPF_PAI" HeaderText="CPF Pai"   Visible="false" FilterControlWidth="35px"
                UniqueName="CPF_PAI"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="NOME_MAE" HeaderText="Nome Mãe"   Visible="false" FilterControlWidth="35px"
                UniqueName="NOME_MAE"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="CPF_MAE" HeaderText="CPF Mãe"   Visible="false" FilterControlWidth="35px"
                UniqueName="CPF_MAE"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_RESPAI" HeaderText="Tel. Residencial Pai"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_RESPAI"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_CELPAI" HeaderText="Celular Pai"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_CELPAI"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_RESMAE" HeaderText="Tel. Residencial Mãe"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_RESMAE"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PSC_TELEFONE_CELMAE" HeaderText="Celular Mãe"   Visible="false" FilterControlWidth="35px"
                UniqueName="PSC_TELEFONE_CELMAE"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PRF_DESCRICAO_PAI" HeaderText="Profissão Pai"  ReadOnly="true" Visible="false" FilterControlWidth="35px"
                UniqueName="PRF_DESCRICAO_PAI"> 
                <HeaderStyle Width="120px" /> 
                <ItemStyle Font-Size="X-Small" Width="120px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="PRF_DESCRICAO_MAE" HeaderText="Profissão Mãe"   Visible="false" FilterControlWidth="35px"
                UniqueName="PRF_DESCRICAO_MAE"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="MAT_DTINCLUSAO" HeaderText="Data Matrícula"   Visible="false" FilterControlWidth="35px"
                UniqueName="MAT_DTINCLUSAO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="MAT_DATACOBRANCA" HeaderText="Data Cobrança"   Visible="false" FilterControlWidth="35px"
                UniqueName="MAT_DATACOBRANCA"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="MATRICULAS" 
                HeaderText="Modalidade - Nível - Turma"   Visible="false" FilterControlWidth="35px"
                UniqueName="MATRICULAS"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="NIV_DESCRICAO" HeaderText="Nível"   Visible="false" FilterControlWidth="35px"
                UniqueName="NIV_DESCRICAO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="TUR_DESCRICAO" HeaderText="Turma"   Visible="false" FilterControlWidth="35px"
                UniqueName="TUR_DESCRICAO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="MAT_VRMENSALIDADE" HeaderText="Valor Base"   Visible="false" FilterControlWidth="35px"
                UniqueName="MAT_VRMENSALIDADE"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="MAT_ISENTOTXPARTICIPACAO" HeaderText="Isento Tx Part."   Visible="false" FilterControlWidth="35px"
                UniqueName="MAT_ISENTOTXPARTICIPACAO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="ALU_BOLSISTA" HeaderText="Bolsista"   Visible="false" FilterControlWidth="35px"
                UniqueName="ALU_BOLSISTA"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn>            
            <telerik:GridBoundColumn DataField="MAT_TXPARTICIPACAO" HeaderText="Vlr Tx. Part."   Visible="false" FilterControlWidth="35px"
                UniqueName="MAT_TXPARTICIPACAO"> 
                <HeaderStyle Width="75px" /> 
                <ItemStyle Font-Size="X-Small" Width="75px" /> 
            </telerik:GridBoundColumn> 
            <telerik:GridBoundColumn DataField="ALU_MEDICAMENTO" HeaderText="Faz uso de medicamento"   Visible="false" FilterControlWidth="35px"
                UniqueName="ALU_MEDICAMENTO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn>             
            <telerik:GridBoundColumn DataField="CNV_DESCRICAO" HeaderText="Convênio"   Visible="false" FilterControlWidth="35px"
                UniqueName="CNV_DESCRICAO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn>             
            <telerik:GridBoundColumn DataField="ALU_OBSERVACAO" HeaderText="Observação"   Visible="false" FilterControlWidth="35px"
                UniqueName="ALU_OBSERVACAO"> 
                <ItemStyle Font-Size="X-Small"  /> 
            </telerik:GridBoundColumn> 

            <%--<telerik:GridEditCommandColumn ButtonType="ImageButton" EditText=""  
                CancelText="" InsertText="" UpdateText="" EditImageUrl="../Imagens/grid_edit.png">             
                <HeaderStyle HorizontalAlign="Center" Width="40px" /> 
                <ItemStyle HorizontalAlign="Center" Width="40px" /> 
            </telerik:GridEditCommandColumn> 
            <telerik:GridButtonColumn ButtonType="ImageButton"  
                CommandName="Delete" ConfirmDialogType="RadWindow"  
                ConfirmText="Deseja realmente excluir este registro"  
                ImageUrl="../Imagens/grid_delete.png" UniqueName="DeleteColumn"  
                ConfirmTitle="Exclusão de registro" Text="Delete"> 
             
                <HeaderStyle HorizontalAlign="Center" Width="40px" /> 
                <ItemStyle HorizontalAlign="Center" Width="40px" /> 
            </telerik:GridButtonColumn> --%>
        </Columns> 
 
    <EditFormSettings> 
    <EditColumn UniqueName="EditCommandColumn1" ButtonType="ImageButton"></EditColumn> 
        <PopUpSettings Modal="True" /> 
    </EditFormSettings> 
    </MasterTableView> 
            </telerik:RadGrid> 
        </telerik:RadAjaxPanel>
              
    </div> 
    <div style="float:right; margin-left:0px; margin-top:150px;" align="right">
        <asp:ImageButton ID="imgbRetornar" runat="server" 
            ImageUrl="~/Imagens/botoes_pagina_retornar.png" 
            onclick="imgbRetornar_Click" />
            
    </div>
    
    </form> 
</body> 
</html>
